CREATE TABLE [dbo].[TMPARA_TESO]
(
[CO_EMPR] [dbo].[TD_VC_002] NOT NULL,
[TI_CAMB] [dbo].[TD_VC_001] NULL,
[TI_ORIG] [dbo].[TD_VC_001] NULL,
[CO_TIAU_CCOS] [dbo].[TD_VC_001] NULL,
[CO_TIAU_CLIE] [dbo].[TD_VC_001] NULL,
[CO_TIAU_PROV] [dbo].[TD_VC_001] NULL,
[CO_TIAU_EMPL] [dbo].[TD_VC_001] NULL,
[NV_INFO_CNTA] [dbo].[TD_IN_001] NULL CONSTRAINT [DF__TMPARA_TE__NV_IN__468862B0] DEFAULT ((0)),
[CO_MONE_DEFA] [dbo].[TD_VC_003] NOT NULL,
[CO_MONE_EXTR] [dbo].[TD_VC_003] NULL,
[CO_CNTA_DIGA] [dbo].[TD_VC_050] NULL,
[CO_CNTA_DIIN] [dbo].[TD_VC_050] NULL,
[CO_MOAJ_CXCB] [dbo].[TD_VC_003] NULL,
[DE_LUGA_GIRO] [dbo].[TD_VC_050] NULL,
[IM_LIIN_AJCC] [dbo].[TD_NU_016_004] NULL CONSTRAINT [DF__TMPARA_TE__IM_LI__477C86E9] DEFAULT ((0)),
[IM_LISU_AJCC] [dbo].[TD_NU_016_004] NULL CONSTRAINT [DF__TMPARA_TE__IM_LI__4870AB22] DEFAULT ((0)),
[CO_MOAJ_CXPA] [dbo].[TD_VC_003] NULL,
[IM_LIIN_AJCP] [dbo].[TD_NU_016_004] NULL CONSTRAINT [DF__TMPARA_TE__IM_LI__4964CF5B] DEFAULT ((0)),
[IM_LISU_AJCP] [dbo].[TD_NU_016_004] NULL CONSTRAINT [DF__TMPARA_TE__IM_LI__4A58F394] DEFAULT ((0)),
[ST_LECB_INGR] [dbo].[TD_VC_001] NULL,
[ST_LECB_EGRE] [dbo].[TD_VC_001] NULL,
[ST_LEDC_INGR] [dbo].[TD_VC_001] NULL,
[ST_LEDC_EGRE] [dbo].[TD_VC_001] NULL,
[PO_COMI_0001] [dbo].[TD_NU_009_004] NULL CONSTRAINT [DF__TMPARA_TE__PO_CO__4B4D17CD] DEFAULT ((0)),
[PO_COMI_0002] [dbo].[TD_NU_009_004] NULL CONSTRAINT [DF__TMPARA_TE__PO_CO__4C413C06] DEFAULT ((0)),
[PO_COMI_0003] [dbo].[TD_NU_009_004] NULL CONSTRAINT [DF__TMPARA_TE__PO_CO__4D35603F] DEFAULT ((0)),
[PO_COMI_0004] [dbo].[TD_NU_009_004] NULL CONSTRAINT [DF__TMPARA_TE__PO_CO__4E298478] DEFAULT ((0)),
[PO_COMI_0005] [dbo].[TD_NU_009_004] NULL CONSTRAINT [DF__TMPARA_TE__PO_CO__4F1DA8B1] DEFAULT ((0)),
[PO_COMI_0006] [dbo].[TD_NU_009_004] NULL CONSTRAINT [DF__TMPARA_TE__PO_CO__5011CCEA] DEFAULT ((0)),
[CO_CNTA_INGR] [dbo].[TD_VC_020] NULL,
[CO_CNTA_EGRE] [dbo].[TD_VC_020] NULL,
[NU_DETA_IMPR] [dbo].[TD_IN_001] NULL CONSTRAINT [DF__TMPARA_TE__NU_DE__5105F123] DEFAULT ((0)),
[CO_MONE_DEF1] [dbo].[TD_VC_003] NULL,
[ST_GEAS_ANUL] [dbo].[TD_VC_001] NULL,
[CO_TIPO_OPER] [dbo].[TD_VC_003] NULL,
[CO_TIPO_OPEG] [dbo].[TD_VC_003] NULL,
[ST_LOGI] [dbo].[TD_VC_001] NULL,
[ST_RRHH] [dbo].[TD_VC_001] NULL,
[ST_PRES] [dbo].[TD_VC_001] NULL,
[ST_ACFI] [dbo].[TD_VC_001] NULL,
[ST_VENT] [dbo].[TD_VC_001] NULL,
[ST_APRO] [dbo].[TD_VC_001] NULL,
[CO_ESTA_PEND] [dbo].[TD_VC_100] NULL,
[CO_ESTA_CANC] [dbo].[TD_VC_100] NULL,
[NU_PORC_RETE] [dbo].[TD_NU_009_004] NULL CONSTRAINT [DF__TMPARA_TE__NU_PO__51FA155C] DEFAULT ((0)),
[ST_AGEN_RETE] [dbo].[TD_VC_001_SINO] NULL CONSTRAINT [DF__TMPARA_TE__ST_AG__52EE3995] DEFAULT ('N'),
[IM_MAXI_NRET] [dbo].[TD_NU_016_004] NULL CONSTRAINT [DF__TMPARA_TE__IM_MA__54D68207] DEFAULT ((0)),
[ST_INTE_BACH] [dbo].[TD_VC_001_SINO] NULL CONSTRAINT [DF__TMPARA_TE__ST_IN__55CAA640] DEFAULT ('N'),
[NU_LINE_RETE] [dbo].[TD_IN_001] NULL CONSTRAINT [DF__TMPARA_TE__NU_LI__57B2EEB2] DEFAULT ((0)),
[TI_OPRG_SIPR] [dbo].[TD_VC_003] NULL,
[ST_CNTB_MTMN] [dbo].[TD_VC_001_SINO] NULL CONSTRAINT [DF__TMPARA_TE__ST_CN__58A712EB] DEFAULT ('N'),
[TI_APCI_CAJA] [dbo].[TD_VC_001] NULL,
[ST_GENE_INTR] [dbo].[TD_VC_001] NULL,
[TI_AUXI_GADM] [dbo].[TD_VC_001] NULL,
[CO_CNTA_ADMI] [dbo].[TD_VC_020] NULL,
[CO_AUXI_GADM] [dbo].[TD_VC_020] NULL,
[CO_CNTA_FINA] [dbo].[TD_VC_020] NULL,
[CO_COPA_PRES] [dbo].[TD_VC_003] NULL,
[TI_AUXI_GFIN] [dbo].[TD_VC_001] NULL,
[ST_APRO_CXPA] [dbo].[TD_VC_001_SINO] NOT NULL CONSTRAINT [DF__TMPARA_TE__ST_AP__5A8F5B5D] DEFAULT ('N'),
[CO_TIOP_DETR] [dbo].[TD_VC_003] NULL,
[CO_CNDT_INGR] [dbo].[TD_VC_020] NULL,
[CO_CNDT_EGRE] [dbo].[TD_VC_020] NULL,
[NU_REGI_DETR] [dbo].[TD_IN_001] NULL CONSTRAINT [DF__TMPARA_TE__NU_RE__5C77A3CF] DEFAULT ((0)),
[NU_LINE_DETR] [dbo].[TD_IN_001] NULL CONSTRAINT [DF__TMPARA_TE__NU_LI__5D6BC808] DEFAULT ((0)),
[DE_NOMB_ORDE] [dbo].[TD_VC_100] NULL,
[TI_DOCU_PRRA] [dbo].[TD_VC_003] NULL,
[CO_TIOP_PRRA] [dbo].[TD_VC_003] NULL,
[CO_PAGO_PRRA] [dbo].[TD_VC_003] NULL,
[CO_CNTA_PRRA] [dbo].[TD_VC_020] NULL,
[TI_AUXI_PRRA] [dbo].[TD_VC_001] NULL,
[CO_AUXI_PRRA] [dbo].[TD_VC_020] NULL,
[CO_ORDE_PRRA] [dbo].[TD_VC_020] NULL,
[ST_ENRE_CAJA] [dbo].[TD_VC_001_SINO] NULL CONSTRAINT [DF__TMPARA_TE__ST_EN__5E5FEC41] DEFAULT ('N'),
[ST_DISP_AUTO] [dbo].[TD_VC_001_SINO] NULL CONSTRAINT [DF__TMPARA_TE__ST_DI__5F54107A] DEFAULT ('N'),
[PC_DETR] [dbo].[TD_NU_009_004] NULL CONSTRAINT [DF__TMPARA_TE__PC_DE__604834B3] DEFAULT ((0)),
[CO_AUXI_GFIN] [dbo].[TD_VC_020] NULL,
[CO_COND_CONT] [dbo].[TD_VC_003] NULL,
[ST_PROV_AUTO] [dbo].[TD_VC_001_SINO] NULL CONSTRAINT [DF__TMPARA_TE__ST_PR__613C58EC] DEFAULT ('N'),
[ST_CNTR_CNDO] [dbo].[TD_VC_001_SINO] NULL CONSTRAINT [DF__TMPARA_TE__ST_CN__6324A15E] DEFAULT ('N'),
[CO_IMPT_DCUR] [dbo].[TD_VC_003] NULL,
[ST_FLUJ_EFEC] [dbo].[TD_VC_001_SINO] NULL CONSTRAINT [DF__TMPARA_TE__ST_FL__650CE9D0] DEFAULT ('N'),
[ST_AGEN_PERC] [dbo].[TD_VC_001_SINO] NULL CONSTRAINT [DF__TMPARA_TE__ST_AG__66010E09] DEFAULT ('N'),
[IM_MAXI_NPER] [dbo].[TD_NU_016_004] NULL CONSTRAINT [DF__TMPARA_TE__IM_MA__66F53242] DEFAULT ((0)),
[PC_PERC_NAGP] [dbo].[TD_NU_009_004] NULL CONSTRAINT [DF__TMPARA_TE__PC_PE__67E9567B] DEFAULT ((0)),
[PC_PERC_SAGP] [dbo].[TD_NU_009_004] NULL CONSTRAINT [DF__TMPARA_TE__PC_PE__68DD7AB4] DEFAULT ((0)),
[PC_PERC_SAGR] [dbo].[TD_NU_009_004] NULL CONSTRAINT [DF__TMPARA_TE__PC_PE__69D19EED] DEFAULT ((0)),
[FE_INIC_PERC] [dbo].[TD_DT_001] NULL,
[NU_LINE_PERC] [int] NULL CONSTRAINT [DF__TMPARA_TE__NU_LI__6AC5C326] DEFAULT ((0)),
[AA_CONC] [dbo].[TD_VC_004] NULL,
[MM_CONC] [dbo].[TD_VC_002] NULL,
[TI_OPER_RETC] [dbo].[TD_VC_003] NULL,
[TI_DOCU_RETC] [dbo].[TD_VC_100] NULL,
[TI_DOCU_PROV] [dbo].[TD_VC_100] NULL,
[CO_CCOS_IGVD] [dbo].[TD_VC_020] NULL,
[CO_ACTI_IGVD] [dbo].[TD_VC_020] NULL,
[ST_CHEQ_UNID] [dbo].[TD_VC_001_SINO] NULL CONSTRAINT [DF__TMPARA_TE__ST_CH__6BB9E75F] DEFAULT ('N'),
[ST_ACTI_MOGA] [dbo].[TD_VC_001] NULL,
[CO_USUA_CREA] [dbo].[TD_VC_008_USUA] NOT NULL CONSTRAINT [DF__TMPARA_TE__CO_US__6DA22FD1] DEFAULT (suser_sname()),
[FE_USUA_CREA] [dbo].[TD_DT_001_SIST] NOT NULL CONSTRAINT [DF__TMPARA_TE__FE_US__6E96540A] DEFAULT (getdate()),
[CO_USUA_MODI] [dbo].[TD_VC_008_USUA] NOT NULL CONSTRAINT [DF__TMPARA_TE__CO_US__6F8A7843] DEFAULT (suser_sname()),
[FE_USUA_MODI] [dbo].[TD_DT_001_SIST] NOT NULL CONSTRAINT [DF__TMPARA_TE__FE_US__707E9C7C] DEFAULT (getdate()),
[TI_DOCU_NCRB] [dbo].[TD_VC_020] NULL,
[CO_CNTA_DESS] [dbo].[TD_VC_020] NULL,
[CO_CNTA_DESD] [dbo].[TD_VC_020] NULL,
[CO_ESTA_BLOQ] [dbo].[TD_VC_003] NULL,
[ST_DISP_AUOC] [dbo].[TD_VC_001] NULL,
[ST_DISP_AUOS] [dbo].[TD_VC_001] NULL,
[ST_DISP_DEVO] [dbo].[TD_VC_001] NULL,
[IM_MINI_ERET] [dbo].[TD_NU_016_004] NOT NULL CONSTRAINT [DF__TMPARA_TE__IM_MI__7172C0B5] DEFAULT ((0)),
[IM_MAXI_ERET] [dbo].[TD_NU_016_004] NOT NULL CONSTRAINT [DF__TMPARA_TE__IM_MA__7266E4EE] DEFAULT ((0)),
[FL_GENE_LETC] [dbo].[TD_VC_050] NULL,
[CO_TIPO_NOPR] [dbo].[TD_VC_003] NULL,
[DE_RUFO_RECE] [dbo].[TD_VC_050] NULL,
[DE_RUFO] [dbo].[TD_VC_050] NULL,
[DE_RUFO_PROC] [dbo].[TD_VC_050] NULL,
[CO_MONE_FACT] [dbo].[TD_VC_003] NULL,
[TI_DOCU_FACT] [dbo].[TD_VC_003] NULL,
[TI_DOCU_BOLE] [dbo].[TD_VC_003] NULL,
[CO_COPA_DEFE] [dbo].[TD_VC_003] NULL,
[NU_SERI_FACT] [dbo].[TD_VC_004] NULL,
[NU_SERI_BOLE] [dbo].[TD_VC_004] NULL,
[CO_TIDO_CHDF] [dbo].[TD_VC_003] NULL,
[CO_ORSE_GADM] [dbo].[TD_VC_020] NULL,
[CO_ORSE_GFIN] [dbo].[TD_VC_020] NULL,
[ST_CTRL_CHDF] [dbo].[TD_VC_001] NULL,
[TI_DOCU_COBA] [dbo].[TD_VC_003] NULL,
[CO_TIOP_NCPA] [dbo].[TD_VC_003] NULL,
[CO_TIOP_NCCO] [dbo].[TD_VC_003] NULL,
[TI_OPRG_NOPR] [dbo].[TD_VC_003] NULL,
[CO_TIOP_NOCC] [dbo].[TD_VC_003] NULL,
[CO_TIOP_NOCO] [dbo].[TD_VC_003] NULL,
[NU_MAXI_DOCU] [dbo].[TD_IN_001] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TMPARA_TESO] WITH NOCHECK ADD CONSTRAINT [CK__TMPARA_TE__ST_AG__53E25DCE] CHECK NOT FOR REPLICATION (([ST_AGEN_RETE]='N' OR [ST_AGEN_RETE]='S'))
GO
ALTER TABLE [dbo].[TMPARA_TESO] WITH NOCHECK ADD CONSTRAINT [CK__TMPARA_TE__ST_AP__5B837F96] CHECK NOT FOR REPLICATION (([ST_APRO_CXPA]='N' OR [ST_APRO_CXPA]='S'))
GO
ALTER TABLE [dbo].[TMPARA_TESO] WITH NOCHECK ADD CONSTRAINT [CK__TMPARA_TE__ST_CH__6CAE0B98] CHECK NOT FOR REPLICATION (([ST_CHEQ_UNID]='N' OR [ST_CHEQ_UNID]='S'))
GO
ALTER TABLE [dbo].[TMPARA_TESO] WITH NOCHECK ADD CONSTRAINT [CK__TMPARA_TE__ST_CN__599B3724] CHECK NOT FOR REPLICATION (([ST_CNTB_MTMN]='N' OR [ST_CNTB_MTMN]='S'))
GO
ALTER TABLE [dbo].[TMPARA_TESO] WITH NOCHECK ADD CONSTRAINT [CK__TMPARA_TE__ST_CN__6418C597] CHECK NOT FOR REPLICATION (([ST_CNTR_CNDO]='N' OR [ST_CNTR_CNDO]='S'))
GO
ALTER TABLE [dbo].[TMPARA_TESO] WITH NOCHECK ADD CONSTRAINT [CK__TMPARA_TE__ST_IN__56BECA79] CHECK NOT FOR REPLICATION (([ST_INTE_BACH]='N' OR [ST_INTE_BACH]='S'))
GO
ALTER TABLE [dbo].[TMPARA_TESO] WITH NOCHECK ADD CONSTRAINT [CK__TMPARA_TE__ST_PR__62307D25] CHECK NOT FOR REPLICATION (([ST_PROV_AUTO]='N' OR [ST_PROV_AUTO]='S'))
GO
ALTER TABLE [dbo].[TMPARA_TESO] ADD CONSTRAINT [PK__TMPARA_T__17D9AB4763B99E3B] PRIMARY KEY CLUSTERED  ([CO_EMPR]) ON [PRIMARY]
GO
